SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweLicenciasHistoricastemp AS SELECT idLicenciaHistorica AS ID, Agente, Licencia, ConOSinGoce, FechaAlta, FechaBaja, Dias, Funcion, Organizacion, Modalidad FROM dbo.tb_LicenciasHistoricastemp 
GO
GRANT SELECT ON  [dbo].[vweLicenciasHistoricastemp] TO [CertificacionesServicios]
GRANT INSERT ON  [dbo].[vweLicenciasHistoricastemp] TO [CertificacionesServicios]
GRANT DELETE ON  [dbo].[vweLicenciasHistoricastemp] TO [CertificacionesServicios]
GRANT UPDATE ON  [dbo].[vweLicenciasHistoricastemp] TO [CertificacionesServicios]
GRANT SELECT ON  [dbo].[vweLicenciasHistoricastemp] TO [MCEEjecutivo]
GRANT SELECT ON  [dbo].[vweLicenciasHistoricastemp] TO [PersonalDocente]
GRANT SELECT ON  [dbo].[vweLicenciasHistoricastemp] TO [PersonalDocenteDireccion]
GRANT SELECT ON  [dbo].[vweLicenciasHistoricastemp] TO [SoloVer]
GO
